<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1">
  <title id="km135496">About the Greenplum Database Utilities</title>
  <shortdesc>General information about using the Greenplum Database utility programs.</shortdesc>
  <body/>
  <topic id="ipv6">
    <title>Referencing IP Addresses</title>
    <body>
      <p>When you reference IPv6 addresses in Greenplum Database utility programs, or when you use
        numeric IP addresses instead of hostnames in any management utility, always enclose the IP
        address in brackets. When specifying an IP address at the command line, the best practice is
        to escape any brackets or enclose them in single quotes. For example, use either:</p>
      <codeblock>\[2620:0:170:610::11\]</codeblock>
      <p>Or:</p>
      <codeblock>'[2620:0:170:610::11]'</codeblock>
    </body>
  </topic>
  <topic id="topic_zqp_5xm_cp">
    <title>Running Backend Server Programs</title>
    <body>
      <p>Greenplum Database has modified certain PostgreSQL backend server programs to handle the
        parallelism and distribution of a Greenplum Database system. You access these programs only
        through the Greenplum Database management tools and utilities. <i>Do not run these programs
          directly.</i></p>
      <p>The following table identifies certain PostgreSQL backend server programs and the Greenplum
        Database utility command to run instead.</p>
      <table id="km164231">
        <title>Greenplum Database Backend Server Programs</title>
        <tgroup cols="3">
          <colspec colnum="1" colname="col1" colwidth="101pt"/>
          <colspec colnum="2" colname="col2" colwidth="188pt"/>
          <colspec colnum="3" colname="col3" colwidth="158pt"/>
          <thead>
            <row>
              <entry colname="col1">PostgreSQL Program Name</entry>
              <entry colname="col2">Description</entry>
              <entry colname="col3">Use Instead</entry>
            </row>
          </thead>
          <tbody>
            <row>
              <entry colname="col1">
                <codeph id="km164249">initdb</codeph>
              </entry>
              <entry colname="col2">This program is called by <codeph>gpinitsystem</codeph> when
                initializing a Greenplum Database array. It is used internally to create the
                individual segment instances and the master instance.</entry>
              <entry colname="col3">
                <xref href="ref/gpinitsystem.xml#topic1" type="topic" format="dita"/>
              </entry>
            </row>
            <row>
              <entry colname="col1">
                <codeph id="km164262">ipcclean</codeph>
              </entry>
              <entry colname="col2">Not used in Greenplum Database</entry>
              <entry colname="col3">N/A</entry>
            </row>
            <row>
              <entry colname="col1">
                <codeph id="km164272">pg_basebackup</codeph>
              </entry>
              <entry colname="col2">This program makes a binary copy of a single database instance.
                Greenplum Database uses it for tasks such as creating a standby master instance, or
                recovering a mirror segment when a full copy is needed. Do not use this utility to
                back up Greenplum Database segment instances because it does not produce
                MPP-consistent backups.</entry>
              <entry colname="col3"><xref href="ref/gpinitstandby.xml#topic1" type="topic"
                  format="dita"/>, <codeph><xref href="ref/gprecoverseg.xml#topic1" type="topic"
                    format="dita"/></codeph></entry>
            </row>
            <row>
              <entry colname="col1">
                <codeph id="km164291">pg_controldata</codeph>
              </entry>
              <entry colname="col2">Not used in Greenplum Database</entry>
              <entry colname="col3"><xref href="ref/gpstate.xml#topic1" type="topic" format="dita"/>
              </entry>
            </row>
            <row>
              <entry colname="col1">
                <codeph id="km164304">pg_ctl</codeph>
              </entry>
              <entry colname="col2">This program is called by <codeph>gpstart</codeph> and
                  <codeph>gpstop</codeph> when starting or stopping a Greenplum Database array. It
                is used internally to stop and start the individual segment instances and the
                master instance in parallel and with the correct options.</entry>
              <entry colname="col3"><xref href="ref/gpstart.xml#topic1" type="topic" format="dita"
                />, <xref href="ref/gpstop.xml#topic1" type="topic" format="dita"/></entry>
            </row>
            <row>
              <entry colname="col1">
                <codeph id="km164320">pg_resetxlog</codeph>
              </entry>
              <entry colname="col2">DO NOT USE<p><b>Warning:</b> This program might cause data loss
                  or cause data to become unavailable. If this program is used, the <ph
                    otherprops="pivotal">Tanzu Greenplum cluster is not supported. The </ph>cluster
                  must be reinitialized and restored<ph otherprops="pivotal"> by the
                  customer</ph>.</p></entry>
              <entry colname="col3">N/A</entry>
            </row>
            <row>
              <entry colname="col1">
                <codeph id="km164330">postgres</codeph>
              </entry>
              <entry colname="col2">The <codeph>postgres</codeph> executable is the actual
                PostgreSQL server process that processes queries.</entry>
              <entry colname="col3">The main <codeph>postgres</codeph> process (postmaster) creates
                other <codeph>postgres</codeph> subprocesses and <codeph>postgres</codeph> session
                as needed to handle client connections.</entry>
            </row>
            <row>
              <entry colname="col1">
                <codeph id="km164337">postmaster</codeph>
              </entry>
              <entry colname="col2"><codeph>postmaster</codeph> starts the <codeph>postgres</codeph>
                database server listener process that accepts client connections. In Greenplum
                Database, a <codeph>postgres</codeph> database listener process runs on the
                Greenplum master Instance and on each Segment Instance.</entry>
              <entry colname="col3">In Greenplum Database, you use <xref
                  href="ref/gpstart.xml#topic1" type="topic" format="dita"/> and <xref
                  href="ref/gpstop.xml#topic1" type="topic" format="dita"/> to start all postmasters
                  (<codeph>postgres</codeph> processes) in the system at once in the correct order
                and with the correct options.</entry>
            </row>
          </tbody>
        </tgroup>
      </table>
    </body>
  </topic>
</topic>
